Search results

Thank you. Will try this one also. Thanks, Siva

Hi, The macro executed first time and unfortunately didn't replace the values. When I tried to execute macro again, it is not executing now. Can you please let me know how to fix it. Thanks, Siva

Please never mind. I understand now. Thanks, Siva

Hi Guido, thanks once again. I didn't understand below statement. May I know where do I need to do. Check via the name manager if rFndRpl refers to the full data range. Replace 31 by your number of rows. Thanks in advance, Siva

To add to my question. I have text like below (I am presenting here small text) 2017-09-28 11:34:07 AM - FirstName LastName (Additional Comments) SEFGE1 rippled out to production. I ran JCLPLUS there and checked to make sure that everything looked perfect. I am expecting it to be 2017-09-28...

Thank you for your quick response. Can you also please explain me how to use your spreadsheet with one example that helps me. Thanks, Siva

Thank you for your quick response. Sorry to say I didn't get how to use it. Can you please explain with one example. Thanks, Siva

Hi, I have a spreadsheet with 153 columns. Most of these columns has free form text. As it has some sensitive information, I need to change this with some label. For example, if I find ABCD, replace it with XYZD. I have around 300 patterns (like ABCD) to find and replace (i.e with XYZD etc..)...

Mark, Thank you for the reply. I would try to upload or mention about source and ressult i am looking for today to have clear picture of what i am expecting. Thank you once again for your quick reply.

Ken, Thank you for the reply. But sorry to say, i didn't get what is the command or script to use to convert into .prn file. The one provided with excel is not giving me the desired output. Thanks, Siva

I am not able to upload the file i have. can i have an email id i can send. Thanks, Siva

Hi, I have a csv file. I am planning to convert it into fixed format text file. I have tried using the option of save as with Formatted Text(Space delimited) (*.prn). But somehow i didn't get the data in fixed format. Could you please let me know what are the option i have to achieve it. It...

Hi, Can we access IMS Database using Excel. If yes could you please let me know how can we do it. Thanks, Siva