Skip to main content
SharePoint

Return to Question

added 21 characters in body; edited title
Source Link
Ganesh Sanap - MVP
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

Sharepoint SharePoint Calculatted column

iI need to create a calculated column to get the number '7261'7261 from the string below... sometimes

Sometimes it can be 4 digits, sometimes 5, so cant use exact character count. I

I tried to use the FIND option and say Find ", Serial", Serial which will work but gives me all the info before ,Serial...,Serial rather than just the 4 characters '72617261. Please

Please help. "service report for notification

String : 404-ED-GREYN-007261, Serial 69530, 999003550472-0003"

service report for notification: 404-ED-GREYN-007261, Serial 69530, 999003550472-0003

Sharepoint Calculatted column

i need to create a calculated column to get the number '7261' from the string below... sometimes it can be 4 digits, sometimes 5, so cant use exact character count. I tried to use the FIND option and say Find ", Serial" which will work but gives me all the info before ,Serial... rather than just the 4 characters '7261. Please help. "service report for notification: 404-ED-GREYN-007261, Serial 69530, 999003550472-0003"

SharePoint Calculatted column

I need to create a calculated column to get the number 7261 from the string below.

Sometimes it can be 4 digits, sometimes 5, so cant use exact character count.

I tried to use the FIND option and say Find , Serial which will work but gives me all the info before ,Serial rather than just the 4 characters 7261.

Please help.

String :

service report for notification: 404-ED-GREYN-007261, Serial 69530, 999003550472-0003

Source Link
marco
marco
  • 47
  • 8

Sharepoint Calculatted column

i need to create a calculated column to get the number '7261' from the string below... sometimes it can be 4 digits, sometimes 5, so cant use exact character count. I tried to use the FIND option and say Find ", Serial" which will work but gives me all the info before ,Serial... rather than just the 4 characters '7261. Please help. "service report for notification: 404-ED-GREYN-007261, Serial 69530, 999003550472-0003"