Search Results

man bash:

and

Try also
ARR1=( $VAR1 )
ARR2=( $VAR2 )
for IX in ${!ARR1[@]}; do echo "${ARR1[IX]}|${ARR2[IX]}"; done
20181225010|906676175
20190224010|907339851
20190224010|907453926
20190303010|907453962...

Hello svks1985,

Could you please try following.

awk 'FNR==NR{a[FNR]=$0;next} {print a[FNR]"|"$0}' <(echo "$var1") <(echo "$var2")


2nd solution: With paste.

paste -d'|' <(echo "$var1")...

Given what was stated in post #3, you might also try something like:
awk '
BEGIN { FS = OFS = "|"
}
NR == 1 {
num = $1
printf("%s", $0)
next
}
{ printf("%s%s", $1 == num ? "\n" : " ", $0)...

Provided there are 14 fields and there is no line break in the last field, try:
awk -F\| '{while(NF<14 && (getline n)>0) $0=$0 OFS n}1' file

$ awk -F\| '$1~/^[0-9]/{printf("\n%s ",$0);next}{printf("%s",$0)}END{print "\n"}' input.txt

113321|107|E|1|828|20|4032832|EL POETA|VILLALOBOS MIJARES PABLO NEPTALI RICARDO...

Hello svks1985,

For any digits(which are present in starting of any line) above code should work. Following explanation could help you in same but it is only for explanation you have to run it in...

Hello svks1985,

Could you please try following and let me know if this helps you.

awk '{printf("%s%s",($0 ~ /^[[:digit:]]/ && NR>1)?RS:((NR>1)?FS:""),$0)} END{print X}' Input_file

Output...

Yet another way of doing the same thing with awk..
awk -F\| '{OFS="|";gsub(",",RS$1FS,$2);print}' file

$
$ cat test.dat
Field1|Field2
123|345,567,789
234|563,560
345|975,098,985,397,984
456|736
$
$
$ awk -F"|" '{n=split($2,a,","); for(i=1;i<=n;++i){print $1"|"a[i]}}' test.dat
Field1|Field2...

Try
awk -F'[\|,]' 'BEGIN {OFS="|"} NR==1 {print;next} {for (i=2;i<=NF;i++) print $1, $i}' file

Try this, test being the input file:
sort -t\: test|paste -sd' \n' -
resulting in
1234:45675:123456 16 bbc1 9813806....... 1234:45675:123456 18 nnb1 98123456.......
2303:13593:137135 16 abc1...