char(10) format

[Mark_E]

hi, i know this has been discussed many times before and i am using a previous example from this site that i searched on but i am getting quite odd results.

my source file is:

a|aa,bb,cc
b|
c|dd

the results i am getting is

a|aa
a|aa
b|
c|dd
c|dd

and i require

a|aa
a|bb
a|cc
b|
c|dd

probably something i am missing out, this is my job design:

stage variable

char(10) : svNewLine
"," : svFieldDelim

Output Columns

DSLink3.f1 : col1
DSLink3.f3 :svNewLine : DSLink3.f1 : svFieldDelim : DSLink3.f3 :col2

thanks again

[ArndW]

Does your input file have 2 columns defined with a delimiter of "|"? If so, how do you get DSLink3.f3?

[Mark_E]

sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up

thanks

[Mark_E]

sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up

thanks

[Mark_E]

sorry, it has more but i'm just using two as an example here as i'm only bring two columns across in the transformer. once i had this working then i was going to build it up

thanks

[ArndW]

NewCol is derived as

Code: Select all

EReplace(",":DSLink3.f2,",",Char(10):DSLink3.f1:"|")

and no stage variables. This assumes that for line 1 f1 is "a" and f2 is "aa,bb,cc".

[Mark_E]

hi,

i tried that but got some odd results.

Output column

DSLink3.f1 : col1
EReplace(",":DSLink3.f2,",",Char(10):DSLink3.f1:"|") : col2

reults as

col1 : col2
a
a|aa
a|bb
a|cc
b
c|dd"


col2 is empty

[Mark_E]

sorry, my mistake, i just needed to format the target file with pipe delimited. the output now is as follows :

col1 col2
a
a aa
a bb
a cc
b
c
c dd

so just need to emilinate the a and c that have col2 as blank somehow