Search text in lines

[anuradhaa]

I have a column in my db and that colum has text like below,

@gsuiguidf #144646 fgedygfeygf #hvdvd

@gfgrtrrrre #232424 tytytuyu #656576

@retrtrytry #265656 fgfhth

I havnt to get the 1st number after # mark when loading data to QV

[sunny_talwar]

May be this:

TextBetween(FieldName, '#', ' ') as Number

[PrashantSangle]

Hi,

Use subfield(FieldName,'#',2)

Edit:

If you want only number then

subfield(subfield(FieldName,'#',2),' ')

Regards

[engishfaque]

Dear Anuradha,

Kindly find attached document, I hope you are looking for that one App.

Kind regards,

Ishfaque Ahmed

[PradeepReddy]

textbetween(Field_Name,'#','#')

[awhitfield]

HI AA,

The following method also works

KeepChar(Subfield(Data,'#',2),'0123456789') as Number

Full Script using inline load:

Data:

Load * Inline

[

Data

@gsuiguidf #144646 fgedygfeygf #hvdvd

@gfgrtrrrre #232424 tytytuyu #656576

@retrtrytry #265656 fgfhth

];

Data2:

Load

KeepChar(Subfield(Data,'#',2),'0123456789') as Number

Resident Data;

HTH Andy