Loading in specific data from a field

[khaycock]

I have a field where which holds a lot of text as it is a description field but I would like to only take the first few sets of numbers that are within each field. The user has inputted these sets of numbers at the beginning of the field and are split up by commas. Is there anyway to force the load of the field in the script to only bring in all numbers at the beginning of the field and nothing else?

The data looks like this:

Then followed by the text.

The field name is [Vulnerability description]. Is this even possible?

[vishsaggi]

You can try using Chr(13) in your subfield like

Subfield(Text, Chr(13),1)

OR

Subfield(Text, Chr(13))

[khaycock]

This didn't work it isn't splitting up the lines. Is there anything else I can try?

[vishsaggi]

Can you share your full expr you are trying to use to get this? I mentioned Text after subfield as just your expr. Like

Subfield(yourexprhere, Chr(13))

[khaycock]

Subfield(Subfield(Subfield(Subfield([IP Address],','),'and'), ' '),'&') AS IPAddress,

This is what I have at the moment due to all the different characters I don't want

[vishsaggi]

Can you share some sample data with this expr please?

[MarcoWedel]

another solution might be:

SubField(Left([Vulnerability description],FindOneOf([Vulnerability description],PurgeChar([Vulnerability description],'0123456789, '))-1),',') as NessusID

hope this helps

regards

Marco