Rejex Pattern is Needed

[sivaramakrishna_raja]

Hi All,

I need to extract the Data after a string value “.com”

Input String

(     Check One:  Sole proprietor  Partnership  C- Corp  S- Corp  LLC  Independent contractor  Eligible self- employed individual  501( c)( 3) nonprofit  501( c)( 19) veterans organization  Tribal business ( sec. 31( b)( 2)( C) of Small Business Act)  Other DBA or Tradename if Applicable Business Legal Name Business Address Business TIN ( EIN, SSN) Business Phone ( ) - Primary Contact Email Address Average Monthly Payroll: $ x 2.5 + EIDL, Net of Advance ( if Applicable) Equals Loan Request: $ Number of Employees: Purpose of the loan ( select more than one): ☐ Payroll ☐ Lease / Mortgage Interest ☐ Utilities ☐ Other ( explain):__________________ Direct Commerce, Inc. 735 Montgomery St # 200, San Francisco, CA 94111- 2116 94- 3357925 415 519 4772 Bruce Hanavan bhanavan@ directcommerce. com 277,450.98 693,627.45 27

Output Should be last line after .com i.es 277,450.98 693,627.45 27

can any one advise the rejex pattern to extract Numerical value after .com charecter

[Anthony_Humphries]

Use this regex to get everything after " .com ":

(?<=\. com ).*.

[sivaramakrishna_raja]

Hi Anthony , Given rejex pattern is not working,

[hasib08 (Motiwala Hasib)]

Try this
(?<=. com\s)\d.*

regex101: build, test, and debug regex

@sivaramakrishna_raja

[Anthony_Humphries]

The regex worked for the text given. If the text given is incorrect, please let us know and repost.

[Pradeep_Shiv]

@sivaramakrishna_raja

(     Check One:  Sole proprietor  Partnership  C- Corp  S- Corp  LLC  Independent contractor  Eligible self- employed individual  501( c)( 3) nonprofit  501( c)( 19) veterans organization  Tribal business ( sec. 31( b)( 2)( C) of Small Business Act)  Other DBA or Tradename if Applicable Business Legal Name Business Address Business TIN ( EIN, SSN) Business Phone ( ) - Primary Contact Email Address Average Monthly Payroll: x 2.5 + EIDL, Net of Advance ( if Applicable) Equals Loan Request: Number of Employees: Purpose of the loan ( select more than one): ☐ Payroll ☐ Lease / Mortgage Interest ☐ Utilities ☐ Other ( explain):__________________ Direct Commerce, Inc. 735 Montgomery St # 200, San Francisco, CA 94111- 2116 94- 3357925 415 519 4772 Bruce Hanavan bhanavan@ directcommerce. com 277,450.98 693,627.45 27

Hello @sivaramakrishna_raja
hope you are doing good!
i’ve tried using this pattern (?<=.\s{0,2}com).\d.+

if this is what you wanted, you can use the above pattern
cheers
@sivaramakrishna_raja