• Post Reply Bookmark Topic Watch Topic
  • New Topic

Regular expression help  RSS feed

 
Prashant Langade
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

My requirement is string containing "Data" at any place/index in a string should be applied the regex.

Like for example my suppose my string is something like "IF(ISERROR(Dataabc_5!A4),\"\",Dataabc_5!A4)", (where A4 is my column/row)
so i want some regex where against which i can match this string and do the processing.i.e i want to increment the row number
that means my end result would be "IF(ISERROR(Dataabc_5!A5),\"\",Dataabc_5!A5)"
Change is A4->A5.

Thanks
Prashant
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!