How to get only Numbers and Symbol from a string

[Ahmad_Rais (Ahmad)]

Hi i need to extract only the number and symbol from a string

example
Input : “ISP202032667-12.pdf”
Output : “202032667-12.pdf”

Thnks

[arjunshenoy]

Hi @Ahmad_Rais

Please use the following RegEx pattern:

(?<=ISP)\d+-\d+\.pdf

Hope this helps,
Best Regards.

[sasi_poosarla (sasi p)]

system.text.regularexpression.regex.match(input,“[\d-]+”).value

[Parvathy (PS Parvathy)]

Hi @Ahmad_Rais
Try using below Regex Expression:

[\d-](.*)

Hope it helps!!
Regards

[mkankatala (Mahesh Kankatala)]

Hi @Ahmad_Rais

Use the regular expressions for the required output. Check the below regular expression.

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=[A-Z]+)\d.*)”)

Hope it helps!!

[Yoichi]

Hi,

If you need to keep extension and remove alphabet in filename without extension, the following will work.

System.Text.RegularExpressions.Regex.Replace(System.IO.Path.GetFileNameWithoutExtension(yourString),"[A-Za-z]","")+System.IO.Path.GetExtension(yourString)

Regards,

[Nitya1 (Nitya Tomar)]

Hi @Ahmad_Rais

Try this-

1. Use the “Assign” activity to define a regular expression pattern. Let’s assume you want to extract numbers and symbols, so the pattern will be [^a-zA-Z]+.
2. Use the “Matches” activity to find all occurrences of the pattern in the input string. Set the “Input” property to the string you want to extract from, and the “Pattern” property to the regular expression pattern defined in step 1.
3. Access the extracted values by iterating through the collection of matches using a “For Each” activity.
4. Concatenate the matched values to form the desired output string.

Thanks!!