Help how to extract first field in a string (csv file)

tini · Post by **tini** » Tue Sep 25, 2007 3:16 am

I have a comma delimite csv file
the data looks like
"qqxx=ABCDFGFDR123,ddc=0,ss=SS,t=test",getline,cool,testing

I want extract ABCDFGFDR123 only.
how do I do that?
could someone hlep me please.
thanks
tini

JoshGeorge · Post by **JoshGeorge** » Tue Sep 25, 2007 3:25 am

Field({InputString},{Delimiter},{Position},[{NumberOfFields}])

Filed(Input.Field,',',1)

Maveric · Post by **Maveric** » Tue Sep 25, 2007 3:39 am

Josh wouldn't that give "qqxx=ABCDFGFDR123" as the output instead of "ABCDFGFDR123"? After extracting the value append it with "=". Then use field function. Something like Filed(Input.Field : "=",'=',2) might work. Otherwise do the concatenation in a stage variable and the use the stage variable in the derivation. Input.Field : "=" will be the StageVar derivation and Filed(StageVar,'=',2) will give you "ABCDFGFDR123".

JoshGeorge · Post by **JoshGeorge** » Tue Sep 25, 2007 3:47 am

That will be

Code: Select all


Field(Field(Input.String,',',1),'=',2)

Maveric, Thanks for pointing it out.

tini · Post by **tini** » Tue Sep 25, 2007 10:50 am

thank you for your quite respond.
I wil try it.
thanks
tini

tini · Post by **tini** » Tue Oct 23, 2007 10:47 pm

can I do this in modify state?
If I can then how is the code?

I try to learn the modify state.
thanks

ArndW · Post by **ArndW** » Tue Oct 23, 2007 10:53 pm

The FIELD function does not exist in a modify stage; only in the transform stage.

tini · Post by **tini** » Tue Oct 23, 2007 11:00 pm

ok, I don't want use transform,
but I still want to extract ABCDFGFDR123 only. Can I do it in Modify state?

ArndW · Post by **ArndW** » Wed Oct 24, 2007 12:22 am

modify stage, not modify state.

You haven't specified how you are reading your file - as one big column, or separated into columns. Your functions in a modify stage are limited to the substring you have already asked about, so if the "=" sign is always in the same position you can use substrings, otherwise you should use a transform stage.

Moderator - Please move to EE/PX Forum

roy · Post by **roy** » Thu Oct 25, 2007 10:51 am

I'm having trouble seeing version 4 with Parallel job type Please update version/job type

tini wrote:I have a comma delimite csv file
the data looks like
"qqxx=ABCDFGFDR123,ddc=0,ss=SS,t=test",getline,cool,testing

I want extract ABCDFGFDR123 only.
how do I do that?
could someone hlep me please.
thanks
tini

DSXchange

Help how to extract first field in a string (csv file)

Help how to extract first field in a string (csv file)

Re: Help how to extract first field in a string (csv file)