in reply to Re^15: How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column
in thread How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column


sorry , pls Ignore my last post of Infinite loop as It was taking much
+ time because of parsing each and every line..

Now with latest code , I am started getting below Issues with exisitin
+g working data kewords 
isim = variable also started printing text after the value i.e. 4 text
+ (vendor/HELP) also getting printed in the cel 

which I don;t want.

Same Is happening with all other variables as well like -> usim/sim_in
+valid ...etc.
Kindly help!

[download]
  • Comment on Re^16: How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column
  • Download Code

Replies are listed 'Best First'.
Re^17: How to read the value of a variable (read from a Excel file converted Into text file) and put then back into Excel column
by poj (Abbot) on Feb 26, 2017 at 17:28 UTC

    As I said, you probably need to add cleaning to specific keywords in the cleanup sub

    # specific cleaning for isim usim sim_invalid
if ( $kw =~ /^(isim|usim|sim_invalid)/ ){
  $value =~ s/(\d+).*/$1/; # remove trailing text
}

    [download]
    poj
[reply]
[d/l]
[select]
      Hi.. Is It possible to keep my search restricted only to the keywords entered in the keywords list as there are some of the keywords exists with duplicate and hence I don;t want to print them in the excel sheet output current e.g. 
      signaling_flag_weight 2 # It's appearing as  _weight 2 however the key
+word Is only signaling_flag=#
ran_type_req # It's appearing as  _req however the keyword Is only ran
+_type=#
emergency_indication = 1 #It's appearing as ication however the keywor
+d Is emergency_ind=#
ipv4_notify_req  #It's appearing as _notify_req however the keyword Is
+ ipv4=#
Ipv6FeatureEnable #It's appearing as FeatureEnable however the keyword
+ only ipv6= #

      [download]
      (2) Iam Not able to search 
      private_uid    =
rat type =
profile.home_uri       =
profile.imei           =
profile.private_uid    =
profile.public_uid     =
ck =

      [download]
[reply]
[d/l]
[select]
        Second Part Is ok now as I have modified the keywords ...i..e from private_uid = to private_uid In the excel Input sheet.
[reply]

In Section Seekers of Perl Wisdom