Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Search text in lines

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

5 Replies
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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
engishfaque
Specialist III
Specialist III

Dear Anuradha,

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

Kind regards,

Ishfaque Ahmed

PradeepReddy
Specialist II
Specialist II

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

awhitfield
Partner - Champion
Partner - Champion

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