Please Login or Register to view this content.
Trying to repeat a 550 or so character statement with a find/replace however I am getting type mismatch errors. When I use a smaller message in the "replace" it works.
I need it to post a message exactly as long as what I have in there. How do I get it to work?
Last edited by ks100; 02-05-2014 at 02:53 PM.
Try:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
for example.Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Originally Posted by Izandol
for example.Please Login or Register to view this content.Please Login or Register to view this content.
Still gives me an error 13 type mismatch, however it works when the string size is only 10. How do I get this to work for a string size of 550?
Last edited by ks100; 02-05-2014 at 01:09 PM.
I think you must loop. Limit is probably 255 characters with Replace.
I'm sure your original post mentioned replacing all blanks in Row 2, with 1200 repeating characters... Was I dreaming?!
Try something like:
Please Login or Register to view this content.
Working thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks