blocks|key|4003277|text|问题清晰度是不存在的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4003278|我已尝试使用此代码检查第一个字段是否为空，希望对您有所帮助。谢谢|4003279|cat+datfile|code-block|syntax|javascript|4003280|1436667%7Cdisne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090%7C""%7C""%7C""%7C""%7C....disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091+disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091“|4003281|#!/bin/bash

VAR=`cat+datfile`
#echo+$VAR



IFS='%7C'+read+-r+FIRST+SECOND+THIRD+FOURTH+FIFTH+SIXTH+SEVENTH+<<<+"$VAR"

echo+$FIRST
echo+$SECOND
echo+$THIRD
echo+$FOURTH
echo+$FIFTH
echo+$SIXTH
echo+$SEVENTH



#+CHECK+First+string+is+empty

if+[+-z+"$FIRST"+]
then
echo+"\$FIRST+is+empty"
else
echo+"\$FIRST+is+not+empty"
fi


+./testlab.sh
+1436667
disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090
""
""
""
""
....disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091+disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091+""+""
$FIRST+is+not+empty|4003282|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Question Clarity doesn't exist. 

<h1>I tried this Code to check first field is empty or not , Hope this help .Thank's</h1>

<pre><code>cat datfile
</code></pre>

1436667|disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090|""|""|""|""|....disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091 disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091 "" ""

<pre><code>#!/bin/bash

VAR=`cat datfile`
#echo $VAR



IFS='|' read -r FIRST SECOND THIRD FOURTH FIFTH SIXTH SEVENTH &lt;&lt;&lt; "$VAR"

echo $FIRST
echo $SECOND
echo $THIRD
echo $FOURTH
echo $FIFTH
echo $SIXTH
echo $SEVENTH



# CHECK First string is empty

if [ -z "$FIRST" ]
then
echo "\$FIRST is empty"
else
echo "\$FIRST is not empty"
fi


 ./testlab.sh
 1436667
disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090
""
""
""
""
....disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091 disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091 "" ""
$FIRST is not empty
</code></pre>

blocks|key|4806662|text|awk+-F+'%7C'+'$1==""+{$1=$2};+$1==+$2+{+$1=$1"_ABC"}+;1'+OFS='%7C'+Asset.csv|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4806663|这对我很有效..谢谢|unstyled|4806664|如果你有更优化的解决方案，你仍然可以分享。|4806665|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>awk -F '|' '$1=="" {$1=$2}; $1== $2 { $1=$1"_ABC"} ;1' OFS='|' Asset.csv
</code></pre>

This worked for me.. thanks 

You can still share if you have more optimized solution.

blocks|key|4003332|text|您可以使用此解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4003333|awk+'BEGIN{FS=OFS="%7C"}+$1==""+&&+$2!=""{$1=$2+"_ABC"}+1'+file|code-block|syntax|javascript|4003334|​|4003335|1436667%7Cdisne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090%7C""%7C""%7C""%7C""%7C....
disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091_ABC%7Cdisne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091%7C""%7C""%7C%7C%7C|4003336|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You may use this solution:

<pre><code>awk 'BEGIN{FS=OFS="|"} $1=="" &amp;&amp; $2!=""{$1=$2 "_ABC"} 1' file
</code></pre>



<pre><code>1436667|disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090|""|""|""|""|....
disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091_ABC|disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091|""|""|||
</code></pre>

I have a dat file as below.

<pre><code>1436667|disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090|""|""|""|""|....
|disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091|""|""|||
</code></pre>

Here "|" is the field seperator.

I have a scenario as below.

I need to check if first column is empty then I have to replace with second column if second column is not empty and add a string to it.

I tried something like below.

<pre><code> awk -F '|' '$2 &amp;&amp; !$1{ $1=$2 }1' Asset.csv
</code></pre>

The above command is removing the field separators and getting output without field separators. If I add string to it like below.

<pre><code>awk -F '|' '$2 &amp;&amp; !$1{ $1=$2+"_ABC" }1' Asset.csv
</code></pre>

First column is coming as 0.

Could you please suggest the way to do it and add a string to it in first column.

Thanks in advance.

replace empty column with other column and add string to it

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个如下的dat文件。1436667|disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897090|""|""|""|""|....|disne-2h.xco.caDIAS0000000000897089-DIAS0000000000897091|""|""|||...

问将空列替换为其他列并向其添加字符串
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将空列替换为其他列并向其添加字符串EN