pratheesh1983
Board Regular
- Joined
- Aug 13, 2015
- Messages
- 55
- Office Version
- 365
- Platform
- Windows
I've a payment data which has a multiple field tags, each field tag have Some info. Eg.
":AT01: ABCDEFG :AT05: 123XYZMU :AT08: AMIT Bangalore India :AT13: Windows Exp. "
The Field ID are named as :AT0..: I need a formula to extract details mentioned in specific Field tag, eg. If I need to extract data for field tag AT13, then the extracted data should be "Windows Exp", or if I need to extract data from :AT01: then it will be "ABCDEFG". Iam looking for a formula if will help me to extract this details from a specific field tag. Could any one please help me with this?
":AT01: ABCDEFG :AT05: 123XYZMU :AT08: AMIT Bangalore India :AT13: Windows Exp. "
The Field ID are named as :AT0..: I need a formula to extract details mentioned in specific Field tag, eg. If I need to extract data for field tag AT13, then the extracted data should be "Windows Exp", or if I need to extract data from :AT01: then it will be "ABCDEFG". Iam looking for a formula if will help me to extract this details from a specific field tag. Could any one please help me with this?